CREATE TABLE [dbo].[ServiceInfo]
(
[Id] [uniqueidentifier] NOT NULL,
[UserInfoId] [uniqueidentifier] NOT NULL,
[ServiceTypeId] [uniqueidentifier] NOT NULL,
[Name] [varbinary] (max) NOT NULL,
[Url] [varbinary] (max) NOT NULL,
[IconImage] [image] NULL,
[DateCreated] [datetime] NOT NULL,
[Deleted] [bit] NOT NULL
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY]
GO
ALTER TABLE [dbo].[ServiceInfo] ADD CONSTRAINT [PK_ServiceInfo] PRIMARY KEY CLUSTERED  ([Id]) ON [PRIMARY]
GO
ALTER TABLE [dbo].[ServiceInfo] ADD CONSTRAINT [FK_ServiceInfo_ServiceType] FOREIGN KEY ([ServiceTypeId]) REFERENCES [dbo].[ServiceType] ([Id])
GO
ALTER TABLE [dbo].[ServiceInfo] ADD CONSTRAINT [FK_ServiceInfo_UserInfo] FOREIGN KEY ([UserInfoId]) REFERENCES [dbo].[UserInfo] ([Id])
GO
